Analysis of Tablets from Amazon¶
Analyzing data of all tablets from amazon.com. Scraped using Scrapy¶
Goal, to analyze differences in products and compare to Amazons brand of tablets, Fire HD tablets.¶
Products were analyzed by Rating of product in stars, number of reviews, popularity, and commonly used words by the seller to market their product.¶
Challenges in Scraping Amazon¶
- Multiple xpaths and tags were needed in order to properply scrape data, and even then some did not scrape appropriately
- Wanted to Scrape Technical details table for system specs however there was no consistency in any of the table formats or tags. Some Technical details page only showed an image rather than a table making it difficult to scrape
- Thus the description was parsed and word cloud was used to see what the common specs were
First lets read the csv file generated by scrapy¶
All Pages of Tablets from amazon scrapped¶
| brand | description | num_reviews | price | rating | title | |
|---|---|---|---|---|---|---|
| 0 | Dragon | ,,[ Native and Latest Android OS ] The Max10 u... | 816 ratings | $149.99 | 4.4 out of 5 stars | Dragon Touch Max10 Tablet, Android 10.0 OS, Oc... |
| 1 | Hoozo | ,,【Latest Ver. Tablets】: Android 8.1 Go OS, 1.... | 2,099 ratings | $91.77 | 3.9 out of 5 stars | Android Tablet 10 Inch, 5G WiFi Tablet, 16 GB ... |
| 2 | vankyo | ,,Faster and More responsive: Equipped with th... | 1,711 ratings | $74.99 | 4.4 out of 5 stars | VANKYO MatrixPad S7 7 inch Tablet, Android 9.0... |
| 3 | Dragon | ,,[Strong and Powerful Performance]: Do what y... | 4,595 ratings | $119.99 | 4.4 out of 5 stars | Dragon Touch Notepad K10 Tablet, 10 inch Andro... |
| 4 | Amazon | A Certified Refurbished Fire 7 Tablet is refur... | 2,140 ratings | $59.99 | 4.4 out of 5 stars | Certified Refurbished Fire 7 Tablet (7" displa... |
| ... | ... | ... | ... | ... | ... | ... |
| 9571 | Fusion5 | ,,10.1 INCH POWERFUL OCTA-CORE TABLET PC WITH ... | NaN | $159.95 | NaN | Fusion5 10.1" 2in1 Google Certified Android La... |
| 9572 | Samsung | ,,Minimal bezel. Maximum view. Watch, stream a... | 8,882 ratings | $206.68 | 4.7 out of 5 stars | SAMSUNG SM-T510NZDFXAR Galaxy Tab A 10.1 64 GB... |
| 9573 | Amazon | 8" HD display, 2X the storage (32 or 64 GB of ... | 30,108 ratings | $89.99 | 4.5 out of 5 stars | All-new Fire HD 8 tablet, 8" HD display, 32 GB... |
| 9574 | Amazon | 10.1" 1080p full HD display; 32 or 64 GB of in... | 77,593 ratings | $149.99 | 4.6 out of 5 stars | Fire HD 10 Tablet (10.1" 1080p full HD display... |
| 9575 | Amazon | 7" IPS display; 16 or 32 GB of internal storag... | 110,184 ratings | $49.99 | 4.4 out of 5 stars | Fire 7 tablet (7" display, 16 GB) - Black |
9576 rows × 6 columns
- Using Scrapy I was able to scrape the following variables: Brand, Description, number of reviews, price, rating, and title
- Scrapy was able to scrape over 9000 products!
- However we want to omit 'Renewed' and 'Refurbished' entries to prevent duplicates
- We also want to remove products which are not tablets
Removal of refurbished and renewed devices¶
| brand | description | num_reviews | price | rating | title | |
|---|---|---|---|---|---|---|
| 0 | Dragon | ,,[ Native and Latest Android OS ] The Max10 u... | 816 ratings | $149.99 | 4.4 out of 5 stars | Dragon Touch Max10 Tablet, Android 10.0 OS, Oc... |
| 1 | Hoozo | ,,【Latest Ver. Tablets】: Android 8.1 Go OS, 1.... | 2,099 ratings | $91.77 | 3.9 out of 5 stars | Android Tablet 10 Inch, 5G WiFi Tablet, 16 GB ... |
| 2 | vankyo | ,,Faster and More responsive: Equipped with th... | 1,711 ratings | $74.99 | 4.4 out of 5 stars | VANKYO MatrixPad S7 7 inch Tablet, Android 9.0... |
| 3 | Dragon | ,,[Strong and Powerful Performance]: Do what y... | 4,595 ratings | $119.99 | 4.4 out of 5 stars | Dragon Touch Notepad K10 Tablet, 10 inch Andro... |
| 5 | PRITOM | ,,★[HIGH PERFORMANCE ANDROID TABLET ] - Pritom... | 235 ratings | $89.99 | 4.0 out of 5 stars | Android Tablet Pritom 10 inch Android 9.0 OS T... |
| ... | ... | ... | ... | ... | ... | ... |
| 9571 | Fusion5 | ,,10.1 INCH POWERFUL OCTA-CORE TABLET PC WITH ... | NaN | $159.95 | NaN | Fusion5 10.1" 2in1 Google Certified Android La... |
| 9572 | Samsung | ,,Minimal bezel. Maximum view. Watch, stream a... | 8,882 ratings | $206.68 | 4.7 out of 5 stars | SAMSUNG SM-T510NZDFXAR Galaxy Tab A 10.1 64 GB... |
| 9573 | Amazon | 8" HD display, 2X the storage (32 or 64 GB of ... | 30,108 ratings | $89.99 | 4.5 out of 5 stars | All-new Fire HD 8 tablet, 8" HD display, 32 GB... |
| 9574 | Amazon | 10.1" 1080p full HD display; 32 or 64 GB of in... | 77,593 ratings | $149.99 | 4.6 out of 5 stars | Fire HD 10 Tablet (10.1" 1080p full HD display... |
| 9575 | Amazon | 7" IPS display; 16 or 32 GB of internal storag... | 110,184 ratings | $49.99 | 4.4 out of 5 stars | Fire 7 tablet (7" display, 16 GB) - Black |
6508 rows × 6 columns
Export csv of cleaned data¶
- Upon inspecting the csv file, all refurbished and renewed devices have been omitted!
- Now we can analyze only orginal posts without having to worry about inflated values due to duplicates
Most Listed Tablet Brands on Amazon¶
Dongdexiu 303 Microsoft 166 SAMSUNG 145 Oudi 135 Chichi 123 Name: brand, dtype: int64
Interestingly the brands with the most products on Amazon are:¶
- Dongdexiu
- Microsoft
- Samsung
- Oudi
- Chichi
Most Popular Tablets by number of ratings¶
If you google most popular tablet brands these come up:¶
- Apple
- Samsung
- Amazon
- Lenovo
- Microsoft
- ASUS
Upon inspecting the data these brands were shown to have devices with number of reviews over 1,000 and at least a 4-star rating.¶
Lets sort the data frames by Top brands and number of reviews¶
| brand | description | num_reviews | price | rating | title | reviews_float | |
|---|---|---|---|---|---|---|---|
| 9439 | Apple | 10. 2-inch Retina display,A10 Fusion chip,Touc... | 45,831 ratings | NaN | 4.8 out of 5 stars | Apple iPad (10.2-inch, Wi-Fi, 32GB) - Gold (Pr... | 45831.0 |
| 1164 | Apple | 9.7-inch Retina display,A10 Fusion chip,Touch ... | 16,445 ratings | $459.00 | 4.8 out of 5 stars | Apple iPad (Wi-Fi + Cellular, 32GB) - Silver (... | 16445.0 |
| 1214 | Apple | 9.7-inch Retina display,A10 Fusion chip,Touch ... | 16,445 ratings | $459.00 | 4.8 out of 5 stars | Apple iPad (Wi-Fi + Cellular, 32GB) - Silver (... | 16445.0 |
| 9504 | Apple | 7.9-inch Retina Display with True Tone and wid... | 7,113 ratings | $384.99 | 4.8 out of 5 stars | Apple iPad mini (Wi-Fi, 64GB) - Gold (Latest M... | 7113.0 |
| 469 | Apple | ,,Apple iOS 8; 9.7-Inch Retina Display; 2048x1... | 6,426 ratings | NaN | 4.7 out of 5 stars | Apple iPad Air 2 MGTX2LL/A 9.7-inches 128 GB T... | 6426.0 |
| brand | description | num_reviews | price | rating | title | reviews_float | |
|---|---|---|---|---|---|---|---|
| 9572 | Samsung | ,,Minimal bezel. Maximum view. Watch, stream a... | 8,882 ratings | $206.68 | 4.7 out of 5 stars | SAMSUNG SM-T510NZDFXAR Galaxy Tab A 10.1 64 GB... | 8882.0 |
| 9570 | Samsung | ,,Minimum bezel. Maximum view: Designed with a... | 5,572 ratings | $99.99 | 4.6 out of 5 stars | SAMSUNG SM-T290NZSAXAR, Galaxy Tab A 8.0" 32 G... | 5572.0 |
| 9175 | Samsung | ,,Android 4.4 Kit Kat OS, 1.2 GHz quad-core pr... | 4,271 ratings | NaN | 4.4 out of 5 stars | Samsung Galaxy Tab 4 (7-Inch, White) | 4271.0 |
| 481 | Samsung | ,,1.6 GHz exynos 7870 octa core Processor. 10.... | 3,813 ratings | NaN | 4.5 out of 5 stars | Samsung Galaxy Tab A SM-T580NZKAXAR 10.1-Inch ... | 3813.0 |
| 308 | SAMSUNG | ,,Android 4.4 Kit Kat OS, 1.2 GHz quad-core Qu... | 3,006 ratings | NaN | 4.3 out of 5 stars | Samsung Galaxy Tab 4 SM-T530NYKAXAR 10.1-Inch ... | 3006.0 |
| brand | description | num_reviews | price | rating | title | reviews_float | |
|---|---|---|---|---|---|---|---|
| 382 | Lenovo | ,,CES WINNER: Smart Tab is the winner of the 2... | 2,941 ratings | $249.99 | 3.9 out of 5 stars | Lenovo Smart Tab M10, 10.1-Inch Alexa-Enabled ... | 2941.0 |
| 9547 | Lenovo | ,,The Lenovo Tab M10 (HD) is one impressive fa... | 2,017 ratings | $149.99 | 4.3 out of 5 stars | Lenovo Tab M10 HD 10.1" Tablet, Android 9.0, 1... | 2017.0 |
| 786 | Lenovo | ,,Android 4.4 KitKat (Up gradable up to latest... | 1,596 ratings | NaN | 4.0 out of 5 stars | Lenovo TAB2 A10 - 10.1" Tablet (ARM Cortex A53... | 1596.0 |
| 12 | Lenovo | ,,Premium look & feel with metal back cover an... | 1,594 ratings | $199.99 | 4.5 out of 5 stars | Lenovo Tab M10 Plus, 10.3" FHD Android Tablet,... | 1594.0 |
| 9301 | Lenovo | ,,A big-screen android tablet optimized for en... | 1,186 ratings | $199.99 | 4.0 out of 5 stars | Lenovo Yoga Tab 3 - HD 8" Android Tablet Compu... | 1186.0 |
| brand | description | num_reviews | price | rating | title | reviews_float | |
|---|---|---|---|---|---|---|---|
| 9575 | Amazon | 7" IPS display; 16 or 32 GB of internal storag... | 110,184 ratings | $49.99 | 4.4 out of 5 stars | Fire 7 tablet (7" display, 16 GB) - Black | 110184.0 |
| 9574 | Amazon | 10.1" 1080p full HD display; 32 or 64 GB of in... | 77,593 ratings | $149.99 | 4.6 out of 5 stars | Fire HD 10 Tablet (10.1" 1080p full HD display... | 77593.0 |
| 46 | Amazon | 8" HD display; 16 or 32 GB of internal storage... | 76,789 ratings | NaN | 4.4 out of 5 stars | Fire HD 8 Tablet (8" HD Display, 32 GB) - Blac... | 76789.0 |
| 9464 | Amazon | Up to 12 hours of battery life, a vibrant 8" H... | 55,657 ratings | NaN | 4.2 out of 5 stars | Fire HD 8 Tablet with Alexa, 8" HD Display, 16... | 55657.0 |
| 9229 | Amazon | 7" IPS display; 8 or 16 GB of internal storage... | 30,838 ratings | NaN | 4.0 out of 5 stars | Fire 7 Tablet (7" display, 16 GB) - Black - (P... | 30838.0 |
| brand | description | num_reviews | price | rating | title | reviews_float | |
|---|---|---|---|---|---|---|---|
| 789 | Microsoft | ,,Intel 4th Generation Core i5 Processor,12-In... | 873 ratings | $643.49 | 4.3 out of 5 stars | Microsoft Surface Pro 3 MQ2-00001 12-Inch Full... | 873.0 |
| 8233 | Microsoft | ,,Intel 4th Generation Core i5 Processor,12-In... | 669 ratings | $1,099.99 | 4.0 out of 5 stars | Microsoft Surface Pro 3 PS2-00001 12-Inch Pro ... | 669.0 |
| 1977 | Microsoft | ,,i5 processor with Intel HD Graphics 4000,4GB... | 556 ratings | $599.99 | 4.4 out of 5 stars | Microsoft Surface Pro Tablet 128 GB Hard Drive... | 556.0 |
| 8185 | Microsoft | ,,i5 processor with Intel HD Graphics 4000,4GB... | 556 ratings | $599.99 | 4.4 out of 5 stars | Microsoft Surface Pro Tablet 128 GB Hard Drive... | 556.0 |
| 121 | Microsoft | ,,Windows 10, 10.8-Inch Display.,Processor Qua... | 498 ratings | $349.99 | 3.9 out of 5 stars | Microsoft Surface 3 Tablet (10.8-Inch, 64 GB, ... | 498.0 |
| brand | description | num_reviews | price | rating | title | reviews_float | |
|---|---|---|---|---|---|---|---|
| 1063 | ASUS | ,,Android 4.1 Jelly Bean, 7 inches Display,NVI... | 2,050 ratings | $289.98 | 3.9 out of 5 stars | ASUS Google Nexus 7 Tablet (7-Inch, 32GB) 2012... | 2050.0 |
| 8927 | ASUS | ,,7-Inch Display,Quad Core 1.2 GHz,16 GB Flash... | 1,694 ratings | NaN | 4.0 out of 5 stars | ASUS MeMOPad HD 7-Inch 16 GB Tablet, Blue (ME1... | 1694.0 |
| 8205 | ASUS | ,,9.7" 2K IPS Display (2048 x 1536) with ASUS ... | 1,599 ratings | NaN | 3.8 out of 5 stars | ASUS ZenPad 3S 10 9.7" (2048x1536), 4GB RAM, 6... | 1599.0 |
| 620 | ASUS | ,,8" IPS Display (2048 x 1536) with ASUS TruVi... | 1,558 ratings | NaN | 3.8 out of 5 stars | ASUS ZenPad S8 8" (2048x1536) 32GB Black Table... | 1558.0 |
| 1423 | ASUS | ,,Android 4.0 Ice Cream Sandwich, 10.1 inches ... | 1,381 ratings | NaN | 3.9 out of 5 stars | ASUS TF300T-A1-BL 10.1-Inch 16GB Tablet (Blue) | 1381.0 |
| brand | description | num_reviews | price | rating | title | reviews_float | |
|---|---|---|---|---|---|---|---|
| 490 | ,,7-inch tablet screen, 1200x1920 (323 ppi), L... | 3,928 ratings | NaN | 4.3 out of 5 stars | Nexus 7 from Google (7-Inch, 16 GB, Black) by ... | 3928.0 | |
| 671 | , 7 inches Display,Qualcomm Snapdragon S4 1.5 ... | 3,113 ratings | $299.99 | 4.2 out of 5 stars | ASUS New Nexus 7 FHD Tablet (7-Inch, 32GB, Black) | 3113.0 | |
| 141 | ,,Keyboard and pen/stylus are sold separately,... | 305 ratings | $998.99 | 4.1 out of 5 stars | Google Pixel Slate 12.3-Inch 2 in 1 Tablet Int... | 305.0 | |
| 686 | ,,308ppi,10.2 inches,8mp rear camera 2 mp fron... | 49 ratings | NaN | 4.0 out of 5 stars | Google Pixel C Tablet 32gb Silver Aluminum WiF... | 49.0 | |
| 9041 | ,,308ppi,10.2 inches,8mp rear camera 2 mp fron... | 49 ratings | NaN | 4.0 out of 5 stars | Google Pixel C Tablet 32gb Silver Aluminum WiF... | 49.0 |
Popularity by number of reviews¶
| Brand | Total Reviews | |
|---|---|---|
| 0 | Amazon | 434741.0 |
| 1 | Apple | 129952.0 |
| 2 | Samsung | 85809.0 |
| 3 | ASUS | 23041.0 |
| 4 | Lenovo | 14376.0 |
| 5 | 7454.0 | |
| 6 | Microsoft | 5858.0 |
Amazon Fire HD being the most highly reviewed tablets with some having nearly 100,000 reviews or more! Making their tablets the most reviewed products on the Amazon market Place¶
Analyzing the Overall rating Scores of Tablets to Amazons Fire HD.¶
- As you can see from the bar chart most tablets have a fairly good Rating between 3-4+ stars
- Roughly 40% for both 3 star and 4 star. And ~ 7.5% for 5 star.
- From this we can infer that overall most customers are satisfied with their tablet purchase from Amazon (88% have 3-star rating or higher)
Now how does Amazons Tablets Compare?¶
- As you can see overall most customers are overwhelmingly satisfed with Amazons brand of tablets. With No 1 star reviews and the vast majority of reviews being 4 stars or higher (Around 85%). Add to the fact that the Fire HD tablets are some of the most highly reviewed products on the Amazon market place its clear that most consumers opt for the Fire HD over other tablet manufactuerers
Price Comparisons¶
- Most tablets on amazon fall below 1000 reviews and are between 50 to 300 dollars
- very high concentration below 100 dollars, a lot of cheap chinese brands
As We can see the most common features listed are:¶
- Tablet PC
- WiFi
- Bluetooth
- Quad Core
- Dual SIM
- Android Tablet
- Core 1.3GHz
- 16GB / 32GB
- touch screen
So we can say most tablets have at minium these features: WiFi, Bluetooth, A quad core processor, Running Android OS, Dual Sim capability, either 16GB or 32 GB internal memory, 1.3Ghz processing speed, and of course a touch screen.¶
Now what are the most common features implemented in the Fire HD Tablet?¶
As We can see the most common features listed are:¶
- Fire Tablet
- watching video
- web watching
- listening music
- Quad Core
- hands free
- hours reading
We can infer from the word cloud that Amazon markets its tablets more towards people looking to do light tasks such as reading, web browsing, and watching videos on their tablet.¶
Conclusion:¶
- Amazon dominates the market on basic tablets for simple every day tasks such as watching videos, reading articles, web browsing, and video conferencing.
- They have the highest rated product having primarily 4-5 star reviews and the highest number of reviews of any other tablet on the Amazon marketplace.
- They have a wide selection of different types of tablets by size, memory, performance, and even kids versions.
- Their product is easily affordable compared to other brands such as the Microsoft Surface or Apple iPad, and their tablets regularly come on sale or include deals.
- Some of them even come built in with the voice assistant Alexa.
Overall the Amazon Fire HD tablet is one of the most reliable tablets you can buy for the money, with solid performance, good battery life, and stellar reviews all across the board you cant go wrong with a Fire HD.¶
Going Forward¶
- Add price comparisons of most popular brands
- average out the prices of popular brands and compare them to the Fire HD Tablet
- Comparison of specs between most popular devices by using N-gram to get a more detailed list
- Create more interactive charts
- Continue cleaning data, unforunately even when setting the filters on amazon.com to "electronics" and "Tablets", there are still several entries scraped which were not Tablets. Even after all the data cleaning there are still a few items that are not tablets in the dataframe.
- There are items listed such as: Clothing, accessories, books, etc. Though not present in high enough frequencies to have an impact on the analysis, these should still be cleaned out.
- Include Review information and more comparisons between Amazons primary competitiors (Samsung, google, apple, etc)